StudentAwardPell

EntityType | Independent
Logical Entity Name | StudentAwardPell
Default Table Name | FaStudentPell
Logical Only | NO
Owner | dbo
Definition |
Note |

StudentAwardPell Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
Id |  | INTEGER | NO |
StudentId |  | INTEGER | NO |
AwardYear |  | CHAR(7) | NO |
TransactionIdentifier |  | CHAR(13) | YES |
Model |  | CHAR(1) | YES |
ModelOverride |  | CHAR(1) | YES |
PrimaryEfc |  | INTEGER | YES |
PrimaryEfcType |  | CHAR(1) | YES |
SecondaryEfc |  | INTEGER | YES |
SecondaryEfcType |  | CHAR(1) | YES |
PellPaidEFC |  | INTEGER | YES |
PellPaidEFCType |  | CHAR(1) | YES |
PellAmount |  | INTEGER | YES |
PellEnrollmentStatus |  | CHAR(1) | YES |
VerificationStatus |  | CHAR(1) | YES |
VerificationTransactionFlag |  | CHAR(2) | YES |
VerificationTrackingFlag |  | CHAR(2) | YES |
AutoZeroEfcFlag |  | BIT | NO |
PrimaryAlternateEfc01 |  | INTEGER | YES |
PrimaryAlternateEfc02 |  | INTEGER | YES |
PrimaryAlternateEfc03 |  | INTEGER | YES |
PrimaryAlternateEfc04 |  | INTEGER | YES |
PrimaryAlternateEfc05 |  | INTEGER | YES |
PrimaryAlternateEfc06 |  | INTEGER | YES |
PrimaryAlternateEfc07 |  | INTEGER | YES |
PrimaryAlternateEfc08 |  | INTEGER | YES |
PrimaryAlternateEfc10 |  | INTEGER | YES |
PrimaryAlternateEfc11 |  | INTEGER | YES |
PrimaryAlternateEfc12 |  | INTEGER | YES |
SecondaryAlternateEfc01 |  | INTEGER | YES |
SecondaryAlternateEfc02 |  | INTEGER | YES |
SecondaryAlternateEfc03 |  | INTEGER | YES |
SecondaryAlternateEfc04 |  | INTEGER | YES |
SecondaryAlternateEfc05 |  | INTEGER | YES |
SecondaryAlternateEfc06 |  | INTEGER | YES |
SecondaryAlternateEfc07 |  | INTEGER | YES |
SecondaryAlternateEfc08 |  | INTEGER | YES |
SecondaryAlternateEfc10 |  | INTEGER | YES |
SecondaryAlternateEfc11 |  | INTEGER | YES |
SecondaryAlternateEfc12 |  | INTEGER | YES |
RejectCodes |  | CHAR(14) | YES |
RejectOverrides |  | CHAR(12) | YES |
AssumptionOverrides |  | CHAR(10) | YES |
FisapIncome |  | INTEGER | YES |
ParentContribution |  | INTEGER | YES |
NumberPaymentPeriods |  | INTEGER | YES |
EnrollDate |  | DATETIME | YES |
AttRfmsPellIdentifierCode |  | CHAR(6) | YES |
OriginationIdentifier |  | CHAR(23) | YES |
OriginationBatchIdentifier |  | VARCHAR(30) | YES |
OriginationStatus |  | CHAR(1) | YES |
OriginationDate |  | DATETIME | YES |
OriginationProcessDate |  | DATETIME | YES |
OriginationRejectCodes |  | CHAR(75) | YES |
OriginationFlags |  | CHAR(10) | YES |
AcademicCalendar |  | CHAR(1) | YES |
PaymentMethodology |  | CHAR(1) | YES |
IncarceratedCode |  | CHAR(1) | YES |
UseSecondaryEfcFlag |  | CHAR(1) | YES |
IsirReceivedDate |  | DATETIME | YES |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
EFCOverride |  | INTEGER | YES |
CreatedUserId |  | INTEGER | NO |
AcceptedTransactionIdentifier |  | CHAR(2) | YES |
CurrentSSN |  | CHAR(16) | YES |
StudentIdentifier |  | VARCHAR(44) | YES |
IsIdentifierChanged |  | BIT | NO |
CpsVerificationIndicator |  | VARCHAR(8) | YES |
CpsHighTransactionNumber |  | INTEGER | YES |
IsEfcRecalculated |  | BIT | NO |
TotalEligibilityUsed |  | MONEY(19, 4) | YES |
AdditionalEligibilityIndicator |  | BIT | NO |
InstitutionalEFC |  | INTEGER | YES |
IsAdministrativeRelief |  | BIT | NO |
LifetimeEligibilityUsed |  | NUMERIC(7, 3) | NO |
ManualDependencyStatusForPLUS |  | CHAR(1) | YES |
IsCareerPathwayAlternativePell |  | BIT | NO |

StudentAwardPell Keys

Key Name | Key Type | Keys
FaStudentPell_OriginationBatchID_N_N_IDX | Inversion Entry | OriginationBatchIdentifier
FaStudentPell_TransactionID_N_N_IDX | Inversion Entry | TransactionIdentifier
FaStudentPell_AwardYear_N_N_IDX | Inversion Entry | AwardYear
FaStudentPell_FaStudentPellID_U_C_IDX | PrimaryKey | Id
UK_FaStudentPell_SyStudentID_AttRFMSPellID_AwardYear | Unique Constraint | StudentId, AttRfmsPellIdentifierCode, AwardYear
FaStudentPell_PEFC_N_N_IDX | Inversion Entry | PrimaryEfc
FaPellDisb_FaStudentPellID_N_N_IDX | Inversion Entry | Id
FaStudentPell_StudentIdentifier_N_N_IDX | Inversion Entry | StudentIdentifier
FaStudentPell_SyStudentID_AttRFMSPellID_AwardYear_TransactionID_Model_PellEnrollmentStatus_FaStudentPellID_U_N_IDX | Alternate Key | StudentId, AttRfmsPellIdentifierCode, AwardYear, TransactionIdentifier, Model, PellEnrollmentStatus, Id
FaStudentPell_SyStudentID_N_N_IDX | Inversion Entry | StudentId
FaStudentPell_OriginationID_N_N_IDX | Inversion Entry | OriginationIdentifier

StudentAwardPell Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
Student | Non-Identifying | One To Zero or More |  |  |  | StudentId | NO
faISIR02 | Non-Identifying | Zero or One to Zero or More |  |  |  | TransactionIdentifier | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
faFAFSA00 | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaFAFSA04 | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaFAFSA05 | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaFAFSA06 | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaFAFSA07 | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaFAFSA08 | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaFAFSA09 | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaFAFSA10 | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaFAFSA11 | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaFAFSA12 | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaFafsa | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaISIR04 | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaISIR05 | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAward | Identifying | One To Zero or More |  |  |  |  | NO
FafsaSummary | Non-Identifying | One To Zero or More |  |  |  |  | NO
SyAudit_FaStudentPell | Non-Identifying | One To Zero or More |  |  |  |  | NO

StudentAwardPell Check Constraints

Check Constraint Name | CheckConstraint

StudentAwardPell Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentAwardPell | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaStudentPell | NO |  |  |

StudentAwardPell Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

StudentAwardPell Data Movement Rules

Name | Type | Rule Text/Value